CREATE TABLE [dbo].[PackageQueue]
(
[PackageQueueKey] [uniqueidentifier] NOT NULL,
[Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PackageQueueReleaseTypeCode] [int] NOT NULL,
[PackageCount] [int] NULL,
[ScheduledTaskKey] [uniqueidentifier] NULL,
[QueueReleaseWorkflowKey] [uniqueidentifier] NOT NULL,
[NotificationGroupKey] [uniqueidentifier] NOT NULL,
[AccessKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[PackageQueue] ADD CONSTRAINT [PK_PackageQueue] PRIMARY KEY CLUSTERED ([PackageQueueKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PackageQueue_AccessKey] ON [dbo].[PackageQueue] ([AccessKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PackageQueue_NotificationGroupKey] ON [dbo].[PackageQueue] ([NotificationGroupKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PackageQueue_PackageQueueReleaseTypeCode] ON [dbo].[PackageQueue] ([PackageQueueReleaseTypeCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PackageQueue_QueueReleaseWorkflowKey] ON [dbo].[PackageQueue] ([QueueReleaseWorkflowKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PackageQueue_ScheduledTaskKey] ON [dbo].[PackageQueue] ([ScheduledTaskKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PackageQueue] ADD CONSTRAINT [FK_PackageQueue_AccessMain] FOREIGN KEY ([AccessKey]) REFERENCES [dbo].[AccessMain] ([AccessKey])
GO
ALTER TABLE [dbo].[PackageQueue] ADD CONSTRAINT [FK_PackageQueue_DocumentMain] FOREIGN KEY ([QueueReleaseWorkflowKey]) REFERENCES [dbo].[DocumentMain] ([DocumentKey])
GO
ALTER TABLE [dbo].[PackageQueue] ADD CONSTRAINT [FK_PackageQueue_GroupMain] FOREIGN KEY ([NotificationGroupKey]) REFERENCES [dbo].[GroupMain] ([GroupKey])
GO
ALTER TABLE [dbo].[PackageQueue] ADD CONSTRAINT [FK_PackageQueue_PackageQueueReleaseTypeRef] FOREIGN KEY ([PackageQueueReleaseTypeCode]) REFERENCES [dbo].[PackageQueueReleaseTypeRef] ([PackageQueueReleaseTypeCode])
GO
ALTER TABLE [dbo].[PackageQueue] ADD CONSTRAINT [FK_PackageQueue_ScheduledTask] FOREIGN KEY ([ScheduledTaskKey]) REFERENCES [dbo].[ScheduledTask] ([ScheduledTaskKey])
GO
ALTER TABLE [dbo].[PackageQueue] ADD CONSTRAINT [FK_PackageQueue_UniformRegistry] FOREIGN KEY ([PackageQueueKey]) REFERENCES [dbo].[UniformRegistry] ([UniformKey])
GO